package com.lanchetech.dao;
import org.apache.ibatis.annotations.Param;

import com.lanchetech.bean.response.ResultData;
import com.lanchetech.bean.vo.FreezeAmountTotalVO;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.Date;

import com.lanchetech.bean.request.FreezeAmountReq;
import com.lanchetech.bean.vo.FreezeAmountVO;
import com.lanchetech.entity.FreezeAmount;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

import java.math.BigDecimal;

@Mapper
public interface FreezeAmountMapper {
    int deleteByPrimaryKey(Long id);

    int insert(FreezeAmount record);

    int insertSelective(FreezeAmount record);

    FreezeAmount selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(FreezeAmount record);

    int updateByPrimaryKey(FreezeAmount record);

    BigDecimal sumByOrderId(@Param("orderId")Long orderId);



    List<FreezeAmountVO> findAllPage(FreezeAmountReq req);

    FreezeAmountTotalVO sumAmountByTenantId(@Param("tenantId") Long tenantId);

    BigDecimal sumAmount();

    FreezeAmount findOneByOrderIdAndType(@Param("orderId")Long orderId,@Param("type")Byte type);



    BigDecimal sumAmountStatistics(FreezeAmountReq req);
}